{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# CNKI_Selenium"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "from lxml.html import fromstring\n",
    "import time\n",
    "from random import random\n",
    "import requests\n",
    "import base64"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "<ipython-input-51-66d562601d91>:11: DeprecationWarning: use options instead of chrome_options\n",
      "  driver = webdriver.Chrome(chrome_options = opts)#desired_capabilities=caps\n"
     ]
    }
   ],
   "source": [
    "from selenium import webdriver\n",
    "from selenium.webdriver.common.desired_capabilities import DesiredCapabilities\n",
    "\n",
    "opts = webdriver.ChromeOptions()\n",
    "opts.add_argument('-no-sandbox')#解决DevToolsActivePort文件不存在的报错\n",
    "opts.add_argument('window-size=1920x3000')#指定浏览器分辨率\n",
    "opts.add_argument('--disable-gpu')#谷歌文档提到需要加上→这个属性来规避bug\n",
    "opts.add_argument('--hide-scrollbars')#隐藏滚动条，应对特殊页面\n",
    "\n",
    "\n",
    "driver = webdriver.Chrome(chrome_options = opts)#desired_capabilities=caps"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "* 如果使用校内网，直接登录[中国知网](https://www.cnki.net/)\n",
    "* 如果使用校外网，请登录[外部访问系统](http://fsso.cnki.net/)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 检查是否登录"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [],
   "source": [
    "driver.get(\"https://www.cnki.net/\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [
    {
     "ename": "ElementNotInteractableException",
     "evalue": "Message: element not interactable\n  (Session info: chrome=91.0.4472.77)\n",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mElementNotInteractableException\u001b[0m           Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-53-4c551f75a584>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0mdriver\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mfind_element_by_xpath\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m'//*[@id=\"headerBox\"]/div[1]/div/div/div[4]'\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mclick\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;32mD:\\Anaconda3\\lib\\site-packages\\selenium\\webdriver\\remote\\webelement.py\u001b[0m in \u001b[0;36mclick\u001b[1;34m(self)\u001b[0m\n\u001b[0;32m     78\u001b[0m     \u001b[1;32mdef\u001b[0m \u001b[0mclick\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     79\u001b[0m         \u001b[1;34m\"\"\"Clicks the element.\"\"\"\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m---> 80\u001b[1;33m         \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_execute\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mCommand\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mCLICK_ELEMENT\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m     81\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     82\u001b[0m     \u001b[1;32mdef\u001b[0m \u001b[0msubmit\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mD:\\Anaconda3\\lib\\site-packages\\selenium\\webdriver\\remote\\webelement.py\u001b[0m in \u001b[0;36m_execute\u001b[1;34m(self, command, params)\u001b[0m\n\u001b[0;32m    631\u001b[0m             \u001b[0mparams\u001b[0m \u001b[1;33m=\u001b[0m \u001b[1;33m{\u001b[0m\u001b[1;33m}\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    632\u001b[0m         \u001b[0mparams\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'id'\u001b[0m\u001b[1;33m]\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_id\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 633\u001b[1;33m         \u001b[1;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_parent\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mexecute\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mcommand\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mparams\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    634\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    635\u001b[0m     \u001b[1;32mdef\u001b[0m \u001b[0mfind_element\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mby\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mBy\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mID\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mvalue\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;32mNone\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mD:\\Anaconda3\\lib\\site-packages\\selenium\\webdriver\\remote\\webdriver.py\u001b[0m in \u001b[0;36mexecute\u001b[1;34m(self, driver_command, params)\u001b[0m\n\u001b[0;32m    319\u001b[0m         \u001b[0mresponse\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mcommand_executor\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mexecute\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mdriver_command\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mparams\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    320\u001b[0m         \u001b[1;32mif\u001b[0m \u001b[0mresponse\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 321\u001b[1;33m             \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0merror_handler\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mcheck_response\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mresponse\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    322\u001b[0m             response['value'] = self._unwrap_value(\n\u001b[0;32m    323\u001b[0m                 response.get('value', None))\n",
      "\u001b[1;32mD:\\Anaconda3\\lib\\site-packages\\selenium\\webdriver\\remote\\errorhandler.py\u001b[0m in \u001b[0;36mcheck_response\u001b[1;34m(self, response)\u001b[0m\n\u001b[0;32m    240\u001b[0m                 \u001b[0malert_text\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mvalue\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'alert'\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mget\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m'text'\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    241\u001b[0m             \u001b[1;32mraise\u001b[0m \u001b[0mexception_class\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mmessage\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mscreen\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mstacktrace\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0malert_text\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 242\u001b[1;33m         \u001b[1;32mraise\u001b[0m \u001b[0mexception_class\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mmessage\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mscreen\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mstacktrace\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    243\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    244\u001b[0m     \u001b[1;32mdef\u001b[0m \u001b[0m_value_or_default\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mobj\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mkey\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mdefault\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mElementNotInteractableException\u001b[0m: Message: element not interactable\n  (Session info: chrome=91.0.4472.77)\n"
     ]
    }
   ],
   "source": [
    "driver.find_element_by_xpath('//*[@id=\"headerBox\"]/div[1]/div/div/div[4]').click()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 校内网_直接登录"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "#校园网ip登录\n",
    "element = driver.find_element_by_id('Button2')\n",
    "element.click()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'中山大学南方学院'"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "element = driver.find_element_by_id('Ecp_loginShowName1')\n",
    "element.get_attribute('innerHTML')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 检查窗口位置"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "* 出现多个窗口，检查窗口位置\n",
    "* 每一个窗口在driver中自动生成唯一的窗口id"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 点击高级检索\n",
    "element = driver.find_elements_by_xpath('//div[@class=\"readvce\"]/a')[0]\n",
    "element.click()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['CDwindow-AFC02BA597DF50EF644D9CD5B6DC7309',\n",
       " 'CDwindow-7F036369DCBBA7DE94FC135CB7D821FC']"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#查看窗口信息（现在打开了两个窗口）\n",
    "driver.window_handles"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'CDwindow-AFC02BA597DF50EF644D9CD5B6DC7309'"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "driver.current_window_handle"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "<ipython-input-14-6c6d5ce6602d>:1: DeprecationWarning: use driver.switch_to.window instead\n",
      "  driver.switch_to_window(driver.window_handles[1])\n"
     ]
    }
   ],
   "source": [
    "driver.switch_to_window(driver.window_handles[1])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 直接搜索栏添加索引词"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "search_index =  {\"theme\": \"智慧物联网\", \"author\": \"\",\"literature\":\"\"}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "## 清空主题input\n",
    "driver.find_element_by_xpath('//*[@id=\"gradetxt\"]/dd[1]/div[2]/input').clear()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "driver.find_element_by_xpath('//*[@id=\"gradetxt\"]/dd[1]/div[2]/input').send_keys(search_index['theme'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "## 清空作者input\n",
    "driver.find_element_by_xpath('//*[@id=\"gradetxt\"]/dd[2]/div[2]/input').clear()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "driver.find_element_by_xpath('//*[@id=\"gradetxt\"]/dd[2]/div[2]/input').send_keys(search_index['author'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "## 清空文献来源input\n",
    "driver.find_element_by_xpath('//*[@id=\"gradetxt\"]/dd[3]/div[2]/input').clear()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "driver.find_element_by_xpath('//*[@id=\"gradetxt\"]/dd[3]/div[2]/input').send_keys(search_index['literature'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "element = driver.find_element_by_xpath('//input[@value=\"检索\"]')\n",
    "element.click()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 点击期刊检索以及选择期刊"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 点击期刊\n",
    "driver.find_element_by_xpath('//ul[@class=\"doctype-menus keji\"]/li/a').click()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "#点击CSSI\n",
    "driver.find_element_by_xpath('//input[@key=\"CSI\"]').click()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "#点击北大核心\n",
    "driver.find_element_by_xpath('//input[@key=\"HX\"]').click()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "driver.find_element_by_xpath('//div[@class=\"search-buttons\"]/input[@class=\"btn-search\"]').click()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 填写query\n",
    "* 可以在高级检索直接检索（只要不精确查找）\n",
    "* 建议专业检索"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 点击专业检索\n",
    "driver.find_element_by_name('majorSearch').click()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'SU=主题,TKA=篇关摘,TI=篇名,KY=关键词,AB=摘要,CO=小标题,FT=全文,AU=作者,FI=第一作者,RP=通讯作者,AF=作者单位,LY=期刊名称,RF=参考文献,FU=基金,             CLC=中图分类号,     SN=ISSN,CN=CN,   DOI=DOI,QKLM=栏目信息,FAF=第一单位,CF=被引频次'"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "driver.find_element_by_xpath('/html/body/div[4]/div/div[2]/div/div[1]/div[2]/dl/dd[1]/p').get_attribute('innerHTML')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [],
   "source": [
    "AI_新媒体_query = '(TI=\"智慧互联网\" and SU=\"人工智能\") OR (TI=\"AI\" and SU = \"网络\")'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [],
   "source": [
    "element = driver.find_element_by_xpath('//textarea')\n",
    "element.clear()\n",
    "element.send_keys(AI_新媒体_query)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 点击检索(点击页面显示50篇+全选)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 显示\n",
    "element = driver.find_element_by_xpath('//*[@id=\"perPageDiv\"]/div/i')\n",
    "element.click()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 50 \n",
    "element = driver.find_element_by_xpath('//*[@id=\"perPageDiv\"]/ul/li[3]')\n",
    "element.click()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 获取页面内容"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>篇名</th>\n",
       "      <th>作者</th>\n",
       "      <th>刊名</th>\n",
       "      <th>发表时间</th>\n",
       "      <th>被引</th>\n",
       "      <th>下载</th>\n",
       "      <th>操作</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>信息化视角下的智慧教育发展思路——评《智慧教育：物联网之教育应用》</td>\n",
       "      <td>程巍; 赵俊强</td>\n",
       "      <td>中国教育学刊</td>\n",
       "      <td>2021-06-10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>基于STM32的智慧家庭设计</td>\n",
       "      <td>刘鹏飞; 张微风; 吴晨旭; 孙晓明</td>\n",
       "      <td>液晶与显示</td>\n",
       "      <td>2021-06-10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>广西智慧柑桔技术构成与发展建议  网络首发</td>\n",
       "      <td>刘吉敏;覃泽林;方辉;曾志康;黄启厅</td>\n",
       "      <td>中国南方果树</td>\n",
       "      <td>2021-06-09 15:40</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>智慧城市感知基站：未来智慧城市的综合感知基础设施  网络首发</td>\n",
       "      <td>陈栋; 张翔; 陈能成</td>\n",
       "      <td>武汉大学学报(信息科学版)</td>\n",
       "      <td>2021-06-02 11:10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>280.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>人工智能与物联网在大气科学领域中的应用  网络首发</td>\n",
       "      <td>张敬林;薛珂;杨智鹏;张峰;张人禾</td>\n",
       "      <td>地球物理学进展</td>\n",
       "      <td>2021-05-31 14:24</td>\n",
       "      <td>NaN</td>\n",
       "      <td>414.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>数字孪生智慧学习空间：内涵、模型及策略</td>\n",
       "      <td>李海峰; 王炜</td>\n",
       "      <td>现代远程教育研究</td>\n",
       "      <td>2021-05-25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>98.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>基于物联网的锻造机床运行信息采集系统设计——评《锻造过程及模具设计》</td>\n",
       "      <td>吴海威; 吴汉灵</td>\n",
       "      <td>锻压技术</td>\n",
       "      <td>2021-05-25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>时空大数据分类体系研究</td>\n",
       "      <td>田立征; 李成名; 刘晓丽; 印洁</td>\n",
       "      <td>测绘通报</td>\n",
       "      <td>2021-05-25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>73.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>新技术赋能市场监管智能化：图景、障碍与进路</td>\n",
       "      <td>王湘军; 庞尚尚</td>\n",
       "      <td>行政论坛</td>\n",
       "      <td>2021-05-25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>LoRa技术在智慧图书馆中的应用研究</td>\n",
       "      <td>周杰</td>\n",
       "      <td>新世纪图书馆</td>\n",
       "      <td>2021-05-20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>135.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>中国智慧城市建设的作用机制与路径探索</td>\n",
       "      <td>郝寿义; 马洪福</td>\n",
       "      <td>区域经济评论</td>\n",
       "      <td>2021-05-14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>480.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>智慧旅游信息平台数据库建设和架构设计</td>\n",
       "      <td>劳国炜</td>\n",
       "      <td>现代电子技术</td>\n",
       "      <td>2021-05-12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>440.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>人工智能赋能下社区智慧养老服务模式及关键技术研究</td>\n",
       "      <td>邢珍珍</td>\n",
       "      <td>护理研究</td>\n",
       "      <td>2021-05-08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>945.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14</td>\n",
       "      <td>大数据背景下智慧医养护一体化5I模式研究</td>\n",
       "      <td>吴方; 李菁; 孙铭阳</td>\n",
       "      <td>河海大学学报(哲学社会科学版)</td>\n",
       "      <td>2021-04-25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>190.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15</td>\n",
       "      <td>“两网”融合规划体系架构与关键技术研究</td>\n",
       "      <td>郑伟民; 张笑弟; 高强; 邹波</td>\n",
       "      <td>电力电容器与无功补偿</td>\n",
       "      <td>2021-04-25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>31.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16</td>\n",
       "      <td>共享经济理念下智慧物流发展的动力及模式研究</td>\n",
       "      <td>李玉琪</td>\n",
       "      <td>商业经济研究</td>\n",
       "      <td>2021-04-21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>496.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>17</td>\n",
       "      <td>智慧图书馆的研究与实践在中国的发展</td>\n",
       "      <td>吴志强; 杨学霞</td>\n",
       "      <td>图书情报工作</td>\n",
       "      <td>2021-04-19 12:04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>518.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18</td>\n",
       "      <td>国际对比视角下我国智慧农业制约因素与发展对策研究——评《智慧农业实践》</td>\n",
       "      <td>谢佩军</td>\n",
       "      <td>灌溉排水学报</td>\n",
       "      <td>2021-04-15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>136.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>19</td>\n",
       "      <td>数字乡村建设：作用机理、现实挑战与实施策略</td>\n",
       "      <td>王胜; 余娜; 付锐</td>\n",
       "      <td>改革</td>\n",
       "      <td>2021-04-15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>875.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20</td>\n",
       "      <td>我国智慧图书馆的发展沿革及构建策略研究</td>\n",
       "      <td>张坤; 查先进</td>\n",
       "      <td>国家图书馆学刊</td>\n",
       "      <td>2021-04-15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>307.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>21</td>\n",
       "      <td>信息技术在农业环境污染防治中的应用</td>\n",
       "      <td>赵玉鑫; 张祎</td>\n",
       "      <td>吉林农业大学学报</td>\n",
       "      <td>2021-04-13 16:02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>164.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22</td>\n",
       "      <td>教育强国视角下智慧校园建设评价指标体系研究</td>\n",
       "      <td>黄艳; 周洪宇; 郝晓雯; 刘军</td>\n",
       "      <td>现代教育管理</td>\n",
       "      <td>2021-04-13</td>\n",
       "      <td>NaN</td>\n",
       "      <td>453.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>23</td>\n",
       "      <td>信息化背景下智慧乡村的特征、类型及其实践路径</td>\n",
       "      <td>袁宇阳</td>\n",
       "      <td>现代经济探讨</td>\n",
       "      <td>2021-04-09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>583.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>24</td>\n",
       "      <td>管道数字孪生体模型及其应用展望  网络首发</td>\n",
       "      <td>陈斯迅; 李在蓉; 王禹钦; 马江涛; 王雪莉</td>\n",
       "      <td>油气储运</td>\n",
       "      <td>2021-04-08 11:34</td>\n",
       "      <td>NaN</td>\n",
       "      <td>247.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>25</td>\n",
       "      <td>智慧农业农村的构建：兼论智能电表在果园中的应用</td>\n",
       "      <td>张伟</td>\n",
       "      <td>中国果树</td>\n",
       "      <td>2021-04-08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>171.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>26</td>\n",
       "      <td>5G+智慧教育：基于智能技术的教育变革</td>\n",
       "      <td>杨俊锋; 施高俊; 庄榕霞; 王运武; 黄荣怀</td>\n",
       "      <td>中国电化教育</td>\n",
       "      <td>2021-04-08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1295.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>27</td>\n",
       "      <td>智慧系统及其在智慧城市应用的前沿技术分析</td>\n",
       "      <td>张彩波</td>\n",
       "      <td>科学技术与工程</td>\n",
       "      <td>2021-04-08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>101.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>28</td>\n",
       "      <td>论我国智慧城市群建设：形态、架构与路径——以江苏智慧城市群为例</td>\n",
       "      <td>胡广伟; 赵思雨; 姚敏; 刘建霞</td>\n",
       "      <td>电子政务</td>\n",
       "      <td>2021-04-02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>718.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>29</td>\n",
       "      <td>智慧教育背景下高校智慧实验室的构建与研究</td>\n",
       "      <td>胡国强; 杨彦荣</td>\n",
       "      <td>实验技术与管理</td>\n",
       "      <td>2021-03-30 14:58</td>\n",
       "      <td>NaN</td>\n",
       "      <td>266.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>30</td>\n",
       "      <td>中外智慧管网发展现状与对策方案</td>\n",
       "      <td>董绍华; 张轶男; 左丽丽</td>\n",
       "      <td>油气储运</td>\n",
       "      <td>2021-03-25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>185.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>31</td>\n",
       "      <td>基于互联网加智慧农业的农科人才培养模式探究</td>\n",
       "      <td>杨娟; 叶进; 马仲辉; 沈方科</td>\n",
       "      <td>实验室研究与探索</td>\n",
       "      <td>2021-03-25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>153.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>32</td>\n",
       "      <td>新时代背景下智慧社区建设：价值、逻辑与路径</td>\n",
       "      <td>曹海军; 侯甜甜</td>\n",
       "      <td>广西社会科学</td>\n",
       "      <td>2021-03-25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>506.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>33</td>\n",
       "      <td>基于BIM、物联网技术的智能管控平台在火灾报警系统中的应用</td>\n",
       "      <td>路永明; 孟繁欣; 李嘉琪; 林子阳; 王宁波</td>\n",
       "      <td>水利水电技术(中英文)</td>\n",
       "      <td>2021-03-20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>68.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>34</td>\n",
       "      <td>建设数字孪生城市的逻辑与创新思考</td>\n",
       "      <td>张新长; 李少英; 周启鸣; 孙颖</td>\n",
       "      <td>测绘科学</td>\n",
       "      <td>2021-03-19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>647.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>35</td>\n",
       "      <td>智能管道物联网网络层构建技术</td>\n",
       "      <td>刘桂志</td>\n",
       "      <td>油气储运</td>\n",
       "      <td>2021-03-18 16:35</td>\n",
       "      <td>NaN</td>\n",
       "      <td>103.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>36</td>\n",
       "      <td>面向智慧城市的合肥智慧供水规划与建设</td>\n",
       "      <td>朱波; 郑飞飞; 刘业政; 姜元春; 穆利</td>\n",
       "      <td>中国给水排水</td>\n",
       "      <td>2021-03-17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>33.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>37</td>\n",
       "      <td>工业4.0下智能铁路前沿技术问题综述</td>\n",
       "      <td>缪炳荣;张卫华;刘建新;周宁;梅桂明</td>\n",
       "      <td>交通运输工程学报</td>\n",
       "      <td>2021-03-16 11:45</td>\n",
       "      <td>NaN</td>\n",
       "      <td>390.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>38</td>\n",
       "      <td>智慧城市建设中的算法歧视及其消除</td>\n",
       "      <td>周荣超</td>\n",
       "      <td>领导科学</td>\n",
       "      <td>2021-03-16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>69.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>39</td>\n",
       "      <td>基于时间线段树的智慧教室录播系统设计</td>\n",
       "      <td>王培培; 陈斯宇</td>\n",
       "      <td>现代电子技术</td>\n",
       "      <td>2021-03-15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>48.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>40</td>\n",
       "      <td>基于ARM技术的智慧农业网络架构布局分析</td>\n",
       "      <td>王瑞锋; 王东升</td>\n",
       "      <td>农机化研究</td>\n",
       "      <td>2021-03-15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>181.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>41</td>\n",
       "      <td>智慧旅游对旅游型乡村振兴发展的影响作用与实现路径</td>\n",
       "      <td>贺剑武</td>\n",
       "      <td>农业经济</td>\n",
       "      <td>2021-03-15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>784.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>42</td>\n",
       "      <td>多系统互动智慧养老服务体系的构建与应用对策</td>\n",
       "      <td>童峰</td>\n",
       "      <td>南通大学学报(社会科学版)</td>\n",
       "      <td>2021-03-15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>207.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>43</td>\n",
       "      <td>5G技术在智能矿山建设中的应用研究</td>\n",
       "      <td>宋建华; 马鹏飞</td>\n",
       "      <td>工矿自动化</td>\n",
       "      <td>2021-03-15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>103.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>44</td>\n",
       "      <td>基于混合感知模型的智慧养老平台的建立与应用</td>\n",
       "      <td>黄欢欢;周科嘉;曹松梅;陈学军;肖明朝</td>\n",
       "      <td>中华护理杂志</td>\n",
       "      <td>2021-03-15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>224.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>45</td>\n",
       "      <td>智慧城市背景下智慧消防建设的SWOT分析</td>\n",
       "      <td>田茂亮</td>\n",
       "      <td>消防科学与技术</td>\n",
       "      <td>2021-03-15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>121.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>46</td>\n",
       "      <td>突发公共事件下智慧城市建设与城市治理转型</td>\n",
       "      <td>王波; 张伟; 张敬钦</td>\n",
       "      <td>科技导报</td>\n",
       "      <td>2021-03-13</td>\n",
       "      <td>NaN</td>\n",
       "      <td>80.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>47</td>\n",
       "      <td>基于物联网的农业大棚生产环境监控系统设计</td>\n",
       "      <td>赵荣阳; 王斌; 姜重然; 邓昀</td>\n",
       "      <td>农机化研究</td>\n",
       "      <td>2021-03-12</td>\n",
       "      <td>1.0</td>\n",
       "      <td>711.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>48</td>\n",
       "      <td>泛在电力物联网的发展分析</td>\n",
       "      <td>周荔丹; 曹祖加; 姚钢; 刘东</td>\n",
       "      <td>现代电力</td>\n",
       "      <td>2021-03-10 07:51</td>\n",
       "      <td>NaN</td>\n",
       "      <td>323.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>49</td>\n",
       "      <td>融合5G的高校图书馆智慧学习服务体系构建</td>\n",
       "      <td>王云弟; 王文韬; 谢阳群; 刘咏梅</td>\n",
       "      <td>图书馆理论与实践</td>\n",
       "      <td>2021-03-10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>112.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>50</td>\n",
       "      <td>智慧图书馆研究现状、建设困境及优化路径研究</td>\n",
       "      <td>杨文建; 邓李君</td>\n",
       "      <td>图书馆理论与实践</td>\n",
       "      <td>2021-03-10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>244.0</td>\n",
       "      <td>下载</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Unnamed: 0                                   篇名                       作者  \\\n",
       "0            1    信息化视角下的智慧教育发展思路——评《智慧教育：物联网之教育应用》                  程巍; 赵俊强   \n",
       "1            2                       基于STM32的智慧家庭设计       刘鹏飞; 张微风; 吴晨旭; 孙晓明   \n",
       "2            3                广西智慧柑桔技术构成与发展建议  网络首发       刘吉敏;覃泽林;方辉;曾志康;黄启厅   \n",
       "3            4       智慧城市感知基站：未来智慧城市的综合感知基础设施  网络首发              陈栋; 张翔; 陈能成   \n",
       "4            5            人工智能与物联网在大气科学领域中的应用  网络首发        张敬林;薛珂;杨智鹏;张峰;张人禾   \n",
       "5            6                  数字孪生智慧学习空间：内涵、模型及策略                  李海峰; 王炜   \n",
       "6            7   基于物联网的锻造机床运行信息采集系统设计——评《锻造过程及模具设计》                 吴海威; 吴汉灵   \n",
       "7            8                          时空大数据分类体系研究        田立征; 李成名; 刘晓丽; 印洁   \n",
       "8            9                新技术赋能市场监管智能化：图景、障碍与进路                 王湘军; 庞尚尚   \n",
       "9           10                   LoRa技术在智慧图书馆中的应用研究                       周杰   \n",
       "10          11                   中国智慧城市建设的作用机制与路径探索                 郝寿义; 马洪福   \n",
       "11          12                   智慧旅游信息平台数据库建设和架构设计                      劳国炜   \n",
       "12          13             人工智能赋能下社区智慧养老服务模式及关键技术研究                      邢珍珍   \n",
       "13          14                 大数据背景下智慧医养护一体化5I模式研究              吴方; 李菁; 孙铭阳   \n",
       "14          15                  “两网”融合规划体系架构与关键技术研究         郑伟民; 张笑弟; 高强; 邹波   \n",
       "15          16                共享经济理念下智慧物流发展的动力及模式研究                      李玉琪   \n",
       "16          17                    智慧图书馆的研究与实践在中国的发展                 吴志强; 杨学霞   \n",
       "17          18  国际对比视角下我国智慧农业制约因素与发展对策研究——评《智慧农业实践》                      谢佩军   \n",
       "18          19                数字乡村建设：作用机理、现实挑战与实施策略               王胜; 余娜; 付锐   \n",
       "19          20                  我国智慧图书馆的发展沿革及构建策略研究                  张坤; 查先进   \n",
       "20          21                    信息技术在农业环境污染防治中的应用                  赵玉鑫; 张祎   \n",
       "21          22                教育强国视角下智慧校园建设评价指标体系研究         黄艳; 周洪宇; 郝晓雯; 刘军   \n",
       "22          23               信息化背景下智慧乡村的特征、类型及其实践路径                      袁宇阳   \n",
       "23          24                管道数字孪生体模型及其应用展望  网络首发  陈斯迅; 李在蓉; 王禹钦; 马江涛; 王雪莉   \n",
       "24          25              智慧农业农村的构建：兼论智能电表在果园中的应用                       张伟   \n",
       "25          26                  5G+智慧教育：基于智能技术的教育变革  杨俊锋; 施高俊; 庄榕霞; 王运武; 黄荣怀   \n",
       "26          27                 智慧系统及其在智慧城市应用的前沿技术分析                      张彩波   \n",
       "27          28      论我国智慧城市群建设：形态、架构与路径——以江苏智慧城市群为例        胡广伟; 赵思雨; 姚敏; 刘建霞   \n",
       "28          29                 智慧教育背景下高校智慧实验室的构建与研究                 胡国强; 杨彦荣   \n",
       "29          30                      中外智慧管网发展现状与对策方案            董绍华; 张轶男; 左丽丽   \n",
       "30          31                基于互联网加智慧农业的农科人才培养模式探究         杨娟; 叶进; 马仲辉; 沈方科   \n",
       "31          32                新时代背景下智慧社区建设：价值、逻辑与路径                 曹海军; 侯甜甜   \n",
       "32          33        基于BIM、物联网技术的智能管控平台在火灾报警系统中的应用  路永明; 孟繁欣; 李嘉琪; 林子阳; 王宁波   \n",
       "33          34                     建设数字孪生城市的逻辑与创新思考        张新长; 李少英; 周启鸣; 孙颖   \n",
       "34          35                       智能管道物联网网络层构建技术                      刘桂志   \n",
       "35          36                   面向智慧城市的合肥智慧供水规划与建设    朱波; 郑飞飞; 刘业政; 姜元春; 穆利   \n",
       "36          37                   工业4.0下智能铁路前沿技术问题综述       缪炳荣;张卫华;刘建新;周宁;梅桂明   \n",
       "37          38                     智慧城市建设中的算法歧视及其消除                      周荣超   \n",
       "38          39                   基于时间线段树的智慧教室录播系统设计                 王培培; 陈斯宇   \n",
       "39          40                 基于ARM技术的智慧农业网络架构布局分析                 王瑞锋; 王东升   \n",
       "40          41             智慧旅游对旅游型乡村振兴发展的影响作用与实现路径                      贺剑武   \n",
       "41          42                多系统互动智慧养老服务体系的构建与应用对策                       童峰   \n",
       "42          43                    5G技术在智能矿山建设中的应用研究                 宋建华; 马鹏飞   \n",
       "43          44                基于混合感知模型的智慧养老平台的建立与应用      黄欢欢;周科嘉;曹松梅;陈学军;肖明朝   \n",
       "44          45                 智慧城市背景下智慧消防建设的SWOT分析                      田茂亮   \n",
       "45          46                 突发公共事件下智慧城市建设与城市治理转型              王波; 张伟; 张敬钦   \n",
       "46          47                 基于物联网的农业大棚生产环境监控系统设计         赵荣阳; 王斌; 姜重然; 邓昀   \n",
       "47          48                         泛在电力物联网的发展分析         周荔丹; 曹祖加; 姚钢; 刘东   \n",
       "48          49                 融合5G的高校图书馆智慧学习服务体系构建       王云弟; 王文韬; 谢阳群; 刘咏梅   \n",
       "49          50                智慧图书馆研究现状、建设困境及优化路径研究                 杨文建; 邓李君   \n",
       "\n",
       "                 刊名              发表时间   被引      下载  操作  \n",
       "0            中国教育学刊        2021-06-10  NaN     NaN  下载  \n",
       "1             液晶与显示        2021-06-10  NaN     NaN  下载  \n",
       "2            中国南方果树  2021-06-09 15:40  NaN     NaN  下载  \n",
       "3     武汉大学学报(信息科学版)  2021-06-02 11:10  NaN   280.0  下载  \n",
       "4           地球物理学进展  2021-05-31 14:24  NaN   414.0  下载  \n",
       "5          现代远程教育研究        2021-05-25  NaN    98.0  下载  \n",
       "6              锻压技术        2021-05-25  NaN    14.0  下载  \n",
       "7              测绘通报        2021-05-25  NaN    73.0  下载  \n",
       "8              行政论坛        2021-05-25  NaN    24.0  下载  \n",
       "9            新世纪图书馆        2021-05-20  NaN   135.0  下载  \n",
       "10           区域经济评论        2021-05-14  NaN   480.0  下载  \n",
       "11           现代电子技术        2021-05-12  NaN   440.0  下载  \n",
       "12             护理研究        2021-05-08  NaN   945.0  下载  \n",
       "13  河海大学学报(哲学社会科学版)        2021-04-25  NaN   190.0  下载  \n",
       "14       电力电容器与无功补偿        2021-04-25  NaN    31.0  下载  \n",
       "15           商业经济研究        2021-04-21  NaN   496.0  下载  \n",
       "16           图书情报工作  2021-04-19 12:04  NaN   518.0  下载  \n",
       "17           灌溉排水学报        2021-04-15  NaN   136.0  下载  \n",
       "18               改革        2021-04-15  NaN   875.0  下载  \n",
       "19          国家图书馆学刊        2021-04-15  NaN   307.0  下载  \n",
       "20         吉林农业大学学报  2021-04-13 16:02  NaN   164.0  下载  \n",
       "21           现代教育管理        2021-04-13  NaN   453.0  下载  \n",
       "22           现代经济探讨        2021-04-09  NaN   583.0  下载  \n",
       "23             油气储运  2021-04-08 11:34  NaN   247.0  下载  \n",
       "24             中国果树        2021-04-08  NaN   171.0  下载  \n",
       "25           中国电化教育        2021-04-08  NaN  1295.0  下载  \n",
       "26          科学技术与工程        2021-04-08  NaN   101.0  下载  \n",
       "27             电子政务        2021-04-02  NaN   718.0  下载  \n",
       "28          实验技术与管理  2021-03-30 14:58  NaN   266.0  下载  \n",
       "29             油气储运        2021-03-25  NaN   185.0  下载  \n",
       "30         实验室研究与探索        2021-03-25  NaN   153.0  下载  \n",
       "31           广西社会科学        2021-03-25  NaN   506.0  下载  \n",
       "32      水利水电技术(中英文)        2021-03-20  NaN    68.0  下载  \n",
       "33             测绘科学        2021-03-19  NaN   647.0  下载  \n",
       "34             油气储运  2021-03-18 16:35  NaN   103.0  下载  \n",
       "35           中国给水排水        2021-03-17  NaN    33.0  下载  \n",
       "36         交通运输工程学报  2021-03-16 11:45  NaN   390.0  下载  \n",
       "37             领导科学        2021-03-16  NaN    69.0  下载  \n",
       "38           现代电子技术        2021-03-15  NaN    48.0  下载  \n",
       "39            农机化研究        2021-03-15  NaN   181.0  下载  \n",
       "40             农业经济        2021-03-15  NaN   784.0  下载  \n",
       "41    南通大学学报(社会科学版)        2021-03-15  NaN   207.0  下载  \n",
       "42            工矿自动化        2021-03-15  NaN   103.0  下载  \n",
       "43           中华护理杂志        2021-03-15  NaN   224.0  下载  \n",
       "44          消防科学与技术        2021-03-15  NaN   121.0  下载  \n",
       "45             科技导报        2021-03-13  NaN    80.0  下载  \n",
       "46            农机化研究        2021-03-12  1.0   711.0  下载  \n",
       "47             现代电力  2021-03-10 07:51  NaN   323.0  下载  \n",
       "48         图书馆理论与实践        2021-03-10  NaN   112.0  下载  \n",
       "49         图书馆理论与实践        2021-03-10  NaN   244.0  下载  "
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "element = driver.find_element_by_id('gridTable')\n",
    "page_html = element.get_attribute('innerHTML')\n",
    "pd.read_html(page_html)[0]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 翻页"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "import time"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "for i in range(0,10):\n",
    "    #获取当页内容\n",
    "    element = driver.find_element_by_id('gridTable')\n",
    "    page_html = element.get_attribute('innerHTML')\n",
    "    pd.read_html(page_html)[0]\n",
    "    # 全选\n",
    "    element = driver.find_element_by_id('selectCheckAll1')\n",
    "    element.click()\n",
    "    Page_next = driver.find_element_by_id('PageNext')\n",
    "    Page_next.click()\n",
    "    time.sleep(8)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "element_download = driver.find_element_by_xpath('//*[@id=\"batchOpsBox\"]/li[1]/a')\n",
    "element_download.click()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['CDwindow-AFC02BA597DF50EF644D9CD5B6DC7309',\n",
       " 'CDwindow-7F036369DCBBA7DE94FC135CB7D821FC',\n",
       " 'CDwindow-B2EEC7BB25CAC402A00348C1CD9DB453']"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#查看窗口信息（现在打开了三个窗口）\n",
    "driver.window_handles"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'CDwindow-7F036369DCBBA7DE94FC135CB7D821FC'"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "driver.current_window_handle"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "<ipython-input-38-0dfe2a1ada8f>:1: DeprecationWarning: use driver.switch_to.window instead\n",
      "  driver.switch_to_window(driver.window_handles[2])\n"
     ]
    }
   ],
   "source": [
    "driver.switch_to_window(driver.window_handles[2])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "download = driver.find_element_by_xpath('//*[@id=\"btn-download-all\"]')\n",
    "download.click()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [],
   "source": [
    "driver.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['CDwindow-AFC02BA597DF50EF644D9CD5B6DC7309',\n",
       " 'CDwindow-7F036369DCBBA7DE94FC135CB7D821FC']"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#查看窗口信息（现在打开了两个窗口）\n",
    "driver.window_handles"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "<ipython-input-46-6c6d5ce6602d>:1: DeprecationWarning: use driver.switch_to.window instead\n",
      "  driver.switch_to_window(driver.window_handles[1])\n"
     ]
    }
   ],
   "source": [
    "driver.switch_to_window(driver.window_handles[1])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [],
   "source": [
    "clear = driver.find_element_by_xpath('//*[@id=\"gridTable\"]/div[1]/div[2]/div[1]/a')\n",
    "clear.click()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in range(11,21):\n",
    "    #获取当页内容\n",
    "    element = driver.find_element_by_id('gridTable')\n",
    "    page_html = element.get_attribute('innerHTML')\n",
    "    pd.read_html(page_html)[0]\n",
    "    # 全选\n",
    "    element = driver.find_element_by_id('selectCheckAll1')\n",
    "    element.click()\n",
    "    Page_next = driver.find_element_by_id('PageNext')\n",
    "    Page_next.click()\n",
    "    time.sleep(8)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "element_download = driver.find_element_by_xpath('//*[@id=\"batchOpsBox\"]/li[1]/a')\n",
    "element_download.click()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "#查看窗口信息（现在打开了三个窗口）\n",
    "driver.window_handles"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "driver.current_window_handle"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# image_url = driver.find_element_by_id('changeVercode').get_attribute('scr')\n",
    "# image_url"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# from PIL import Image\n",
    "# from io import BytesIO\n",
    "# import base64\n",
    "# image_本地链接 = 'C:/Users/Desktop/1.jpg'\n",
    "# def baidu_API_OCR(image_url):\n",
    "    ## 1.获取百度API\n",
    "#      host = 'https://aip.baidubce.com/rest/2.0/ocr/v1/general?access_token=24.f9ba9c5241b67688bb4adbed8bc91dec.2592000.1485570332.282335-8574074'\n",
    "#     response = requests.get(host)\n",
    "#     if response:\n",
    "#     #     print(response.json())\n",
    "#             access_token = response.json()[\"access_token\"]\n",
    "#         request_url = \"https://aip.baidubce.com/rest/2.0/ocr/v1/general_basic\"\n",
    "#         params = {\n",
    "#             \"url\":image_url\n",
    "#         }\n",
    "#         request_url = request_url + \"?access_token=\" + access_token\n",
    "#         headers = {'content-type': 'application/x-www-form-urlencoded'}\n",
    "#         response = requests.post(request_url, data=params, headers=headers)\n",
    "#         results = response.json()\n",
    "#         response\n",
    "        \n",
    "#         request_url = \"https://aip.baidubce.com/rest/2.0/ocr/v1/general_basic\"\n",
    "#     # 二进制方式打开图片文件\n",
    "#     f = open('[本地文件]', 'rb')\n",
    "#     img = base64.b64encode(f.read())\n",
    "\n",
    "#     params = {\"image\":img}\n",
    "#     access_token = '[调用鉴权接口获取的token]'\n",
    "#     request_url = request_url + \"?access_token=\" + access_token\n",
    "#     headers = {'content-type': 'application/x-www-form-urlencoded'}\n",
    "#     response = requests.post(request_url, data=params, headers=headers)\n",
    "#     if response:\n",
    "#         print (response.json())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# baidu_API_OCR(image_url)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# for i in range(0,120):\n",
    "# #     if driver.find_element_by_id('changeVercode'):\n",
    "# #         # 解决验证码\n",
    "# #         # 调用API解决验证码的方法/fuc 返回一个结果result 就是我们的vercode\n",
    "# #         image_url = driver.find_element_by_id('changeVercode').get_attribute('scr')\n",
    "\n",
    "# #         vercode = baidu_API_OCR()\n",
    "# #         driver.find_element_by_id('vericode').send_keys(vercode)\n",
    "# #         driver.find_element_by_id('checkCodeBtn').click\n",
    "        \n",
    "# #     else:\n",
    "\n",
    "#         element = driver.find_element_by_id('PageNext')\n",
    "#         element.click()\n",
    "#         time.sleep(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.3"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}
